Open Invoice Report

The Open Invoice Report shows the invoiced orders and miscellaneous debits released for the due date and vendors you specify. The invoiced transactions are open until they are paid in full.

Before you can produce the report, use the Change Invoice Status function or the Hold/Release Invoices function to release the invoices for the report that were not posted with a released status.

NOTE: Invoices for vendors that are on hold are included in the Open Invoice Report, but payments are not prepared for those vendors.

  1. Use the Data Filter to select the range of filtering options or leave the filter blank to include all available data.  
  2. Select the type of invoices to view in the report from the View section.
  3. Select the Invoices due date from the Due Dates section.
    Note: Invoices that are due on or before this date are included in the report.
  4. Select the Discounts due date from the Due Dates section.
    Note: Invoices that are discounted on, or after this date are included in the report.
  5. If you use multicurrency, these print options are available:
    • To print transactions that were entered in the base currency, select the base currency as the report currency and clear the Print All In Base Currency box. Only transactions that were entered in the base currency are printed on the journal.
    • To print transactions that were entered in a currency other than the base currency, select that currency as the report currency. Only transactions that were entered in the currency you select are printed on the journal.
    • To print all transactions (regardless of the currency in which they were entered), select the base currency as the report currency and select the Print All In Base Currency check box.

    Traverse converts all transaction amounts from their original currency to the base currency (if necessary), then prints all transactions on the journal.

  6. Select whether to expand all of the vendor's open invoice list using the Expand All check box. If you do not mark Expand All, you will have a plus (+) sign next to the vendor, when you preview the report. When you click on the plus (+) you will see all the invoices for that vendor that meet the selection criteria.
  7. Select, if applicable, the Banded Rows check box to highlight alternating lines on the report to make the report easier to read.
    Note: Use the System Manager Print Preferences function in the System Manager>Company Setup>Business Rules function to define the default setting for this check box. You can then override this default when you print the report.
  8. Click a command button to 
    9. Click To
    Print Process the Open Invoice Report.
    Output Output the report as a PDF.
    Send Save the report as a PDF and attach it to an email using your default mail program.
    Preview View a preview of the Open Invoice Report.
    Reset Set all fields to their default values.